﻿CREATE TABLE [dbo].[Users] (
    [UserID]                        INT            IDENTITY (87, 1) NOT NULL,
    [UserName]                      NVARCHAR (50)  NOT NULL,
    [RoleID]                        INT            NOT NULL,
    [Password]                      VARCHAR (20)   NULL,
    [FullName]                      VARCHAR (50)   NULL,
    [UserTypeID]                    INT            NOT NULL,
    [ExpectedHours]                 SMALLINT       NOT NULL,
    [IsActive]                      BIT            NOT NULL,
    [Salt]                          VARCHAR (128)  NULL,
    [StartDate]                     DATETIME       NULL,
    [IsAdministrative]              BIT            NOT NULL,
    [PTOHoursRolledIntoCurrentYear] DECIMAL (6, 2) NULL
);

